/*
 Navicat Premium Data Transfer

 Source Server         : lisua
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : student

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 03/04/2025 09:40:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (1, '钟嘉盈', '2370600101', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (2, '卢小霞', '2370600102', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (3, '李志鹏', '2370600103', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (4, '林秋婷', '2370600104', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (5, '叶碧倩', '2370600105', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (6, '吴嘉茵', '2370600106', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (7, '黄嘉宜', '2370600107', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (8, '张家伦', '2370600108', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (9, '张惠', '2370600109', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (10, '张欣', '2370600110', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (11, '黄荣森', '2370600111', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (12, '覃善毅', '2370600112', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (13, '杨迎', '2370600113', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (14, '黄博熠', '2370600114', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (15, '苏小勇', '2370600115', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (16, '程铭友', '2370600116', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (17, '蔡耿城', '2370600117', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (18, '梁国晓', '2370600118', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (19, '吴泽权', '2370600119', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (20, '蔡景财', '2370600120', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (21, '陈川', '2370600121', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (22, '柯锦辉', '2370600122', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (23, '黄婉纯', '2370600123', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (24, '金立群', '2370600124', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (25, '邓丽红', '2370600125', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (26, '黄勇', '2370600126', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (27, '李建浩', '2370600127', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (28, '赵颖毅', '2370600128', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (29, '朱泽炜', '2370600129', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (30, '贺志鹏', '2370600130', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (31, '陈海丽', '2370600131', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (32, '陈荧霞', '2370600132', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (33, '刘海鹏', '2370600133', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (34, '秦菲雪', '2370600134', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (35, '秦思懿', '2370600135', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (36, '赵俊逸', '2370600136', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (37, '曾昊天', '2370600137', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (38, '李瑾玉', '2370600138', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (39, '张壹', '2370600139', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (40, '李彬', '2370600140', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (41, '吴迪', '2370600141', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (42, '刘胜', '2370600142', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (43, '罗俊健', '2370600143', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (44, '周淼', '2370600144', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (45, '余桂侨', '2370600145', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (46, '叶华林', '2370600146', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (47, '陈紫娟', '2370600147', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (48, '黄绍濠', '2370600148', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (51, 'test2', '12345', 1);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (52, 'test2', '12345', NULL);
INSERT INTO `student` (`id`, `name`, `number`, `class_id`) VALUES (53, 'test', '12345', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
